I am currently using SQL Server 2005 and jasperserver v3. I have install the jasperserver in tomcat 5.5 and realized that there's a problem when I wanted to create a domain.
I have created new datasource to my database and successfully connected. In the schema selection popup, using my own database schema (not dbo), the schema name doesn't showed up. But it was showing the database username. so currently I have to create a database that has a username exactly the same as the schema name.
Is there any way that I can configured the jasperserver, so it detects the database schema rather than the username?
Wrong database schema loaded when creating domain
in Products
Posted
Hi,
I am currently using SQL Server 2005 and jasperserver v3. I have install the jasperserver in tomcat 5.5 and realized that there's a problem when I wanted to create a domain.
I have created new datasource to my database and successfully connected. In the schema selection popup, using my own database schema (not dbo), the schema name doesn't showed up. But it was showing the database username. so currently I have to create a database that has a username exactly the same as the schema name.
Is there any way that I can configured the jasperserver, so it detects the database schema rather than the username?
thnx, ipan_kms.