This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Created attachment 132743 [details] Description error from console Hi! I have Netbeans 7.0.1 and Oracle database with the CL8RK1048 (note 387710.1). Also i have SQL DEVELOPER 3.2.20.09.87 with gdk_custom.jar in jlib. With sql developer not problem, so i put in jlib gdk_custom.jar (note 387710.1). I have succeful connect to base, but i can't open any tables. It gives error in file. Steps: 1. Open Netbeans 2. Create new conection for base. 3. Choose JDBS Thin (with service ID (SID)) 4. In locate driver i added: 1. ojdbc6.jar from sqldeveloper/jdbc/lib 2. orai18n.jar from sqldeveloper/jlib 3. gdk_custom.jar from sqldeveloper/jlib 5. Choose APPS schema
Created attachment 132767 [details] Log file with error Log file with error
Hello, did you try to connect to the database with another JDBC driver? E.g. with some standalone driver downloaded from Oracle website? Thanks.
Hello, I tried. I have downloaded ojdbc6.jar, orai18n.jar since http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html for 11.2.0.3, 11.2.0.2.0, 11.2.0.1.0 and puted in alone folder "TEST". But i couldn't connect to database. Then i took orai18n-mapping.jar, gdk_custom.jar from jlib and puted in one. And only after this step i could connect to database. But i got same error. (In reply to comment #2) > Hello, > did you try to connect to the database with another JDBC driver? E.g. with some > standalone driver downloaded from Oracle website? > Thanks.
Did you generate custom gdk_custom.jar file, as described here http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch13custlocale.htm (bottom of the page)? It seems that encoding CL8RK1048 is not directly supported by the database, so the JDBC driver may work incorrectly. Do you have some DB schema with name that contains non-ASCII characters? It could be problem for the JDBC driver. (SQL Developer may use different way for obtaining information about schemas, so it works there).
1. I generated gdk_custom.jar using Oracle Locale Building. 2. I have on my laptop Oracle Database 11.2.0 with NLS_CHARACTERSET = AL32UTF8. Netbeans connect it and work good. In Netbeans in locate driver i choose only ojdbc6.jar. (In reply to comment #4) > Did you generate custom gdk_custom.jar file, as described here > http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch13custlocale.htm > (bottom of the page)? > > It seems that encoding CL8RK1048 is not directly supported by the database, so > the JDBC driver may work incorrectly. > Do you have some DB schema with name that contains non-ASCII characters? It > could be problem for the JDBC driver. (SQL Developer may use different way for > obtaining information about schemas, so it works there).
(In reply to comment #5) > > Do you have some DB schema with name that contains non-ASCII characters? I mean, do you have some user (schema) with name that contains non-Latin characters (e.g. Cyrillic characters) in the database that uses encoding CL8RK1048? You can try to execute "select username from all_users;" to check it. I currently have no idea what could be fixed in NetBeans. The exception was thrown by the JDBC driver, so it seems to be rather a driver issue. Didn't you try to create a Java application that connects to the database using the same JDBC driver? Something similar to code sample in http://wiki.netbeans.org/GetStartedwithJavaDB. Thank you.
1. In our oracledatabase we havn't any schema than contains non-ASCII characters 2. I'm not java programmer, so i can't create Java application. (In reply to comment #6) > (In reply to comment #5) > > > Do you have some DB schema with name that contains non-ASCII characters? > I mean, do you have some user (schema) with name that contains non-Latin > characters (e.g. Cyrillic characters) in the database that uses encoding > CL8RK1048? > > You can try to execute "select username from all_users;" to check it. > > > I currently have no idea what could be fixed in NetBeans. The exception was > thrown by the JDBC driver, so it seems to be rather a driver issue. > > Didn't you try to create a Java application that connects to the database using > the same JDBC driver? Something similar to code sample in > http://wiki.netbeans.org/GetStartedwithJavaDB. > Thank you.
(In reply to Jaroslav Havlin from comment #6) > I currently have no idea what could be fixed in NetBeans. The exception was > thrown by the JDBC driver, so it seems to be rather a driver issue. I agree with Jarda, therefore I'm closing this issue as WONTFIX.