Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Click to select a database driver from the available drivers window. If this is your first visit, be sure to check out the FAQ by clicking the link above. put all C:\oracle\Ora9i\jdbc\lib\classes12.zip and C:\oracle\Ora9i\jdbc\lib\classes111.zip before the TIBCO reference in the CLASSPATH system variable (I am on a windows platform) .
It looks as if the driver is pointed to another database. 0 What is SQL Server and how does it work? Is this a specific database? 0 LVL 33 Overall: Level 33 Microsoft SQL Server 13 Microsoft SQL Server 2005 10 Java 1 Message Active today Author Comment by:knightEknight ID: 207331882008-01-24 sunny replied Oct 8, 2004 Dear Friends: I put the following java code in java activity in BW5=2E1=2E2, compile ok, but has run error, =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= 3D=3D=3D=3D=3Dcode=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D package JavaJDBC=2EJDBC; import The time now is 03:02 PM.
Open a graph. 2. Resolving the problem In the Database connection configuration screen the JDBC specific needs to be set to "Initiate Oracle" not "Oracle"..... Make sure you have added the Oracle driver zip file to the classpath used by Designer if you are running in debug mode, or if you are deploying and running an Thanks sunny Reply With Quote October 8th, 2004,10:42 AM #2 cjard View Profile View Forum Posts Elite Member Power Poster Join Date Oct 2003 Location .NET2.0 / VS2005 Developer Posts 7,104
This opens the database connections window. Click the Validate button to validate the database connection. 7. at com.tibco.plugin.java.JavaMethodActivity.for(JavaMethodActivity.java:330) at com.tibco.plugin.java.JavaMethodActivity.eval(JavaMethodActivity.java:115) at com.tibco.pe.plugin.Activity.eval(Activity.java:207) at com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:398) at com.tibco.pe.core.Job.a(Job.java:591) at com.tibco.pe.core.Job.if(Job.java:443) at com.tibco.pe.core.JobDispatcher$a.a(JobDispatcher.java:270) at com.tibco.pe.core.JobDispatcher$a.run(JobDispatcher.java:218) ================================================= How can I release this embeded locked Oracle JDBC Driver for my current uas?? I'm trying to use driver in par to access DB, as followed:Copy Codeprivate String JdbcDriver = "com.sap.nwmss.jdbc.sqlserver.SQLServerDriver"; private String JdbcUrl = "jdbc:nwmss:sqlserver://ep6sp9test:1433;databasename=UM"; private String User = "sa"; private String Pass =
sunny replied Oct 8, 2004 Thanks all daer friends. Check the Oracle docs or samples for the URL format. Start a new thread here 567172 Related Discussions How can I pass Object from bewteen 2 java code in BW 5.1.2 SSO call error in BW Java to DB2 Exceptions java Procedure 1.
This URL determines which driver class is used, it is ok to have both drivers in your classpath (though probably not necessary). Does the reference to the Oracle JDBC class (d:\jdbc\oracle\jdbc\lib\classes12.zip) come before the TIBCO reference in the CLASSPATH variable (assuming you are on a windows platform!)? This Driver Is Locked For Use With Embedded Applications + Tibco All rights reserved. Historical Number 1539 Document information More support for: Initiate Master Data Service Software version: Version Independent Operating system(s): Platform Independent Reference #: 1471612 Modified date: 23 September 2014 Site availability Site
then close all existing designer and open a new designer. Join our community for more solutions or to ask questions. Good luck! sunny asked Oct 8, 2004 | Replies (15) Dear Friends: I put the following java code in java activity in BW5=2E1=2E2, compile ok, but has run error, =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= 3D=3D=3D=3D=3Dcode=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The problem began when I integrated this portion of the application (which hits SQL Server 2005) with the rest of the legacy app (which hits SQL 2000). Take Survey Now! I have seen the "...embedded.." error before, don't remember the exact cause, have a vague idea that it was related to having multiple jdbc jar =66iles in the classpath, I mean this page On-Demand Webinars (sponsored) → Build Planet-Scale Apps with Azure Cosmos DB in Minutes → It Might be Time to Upgrade Your Database If... → DevSecOps: Balance Speed and Agility with Security
sunny Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Click Finish. you can't use "jdbc:tibcosoftwareinc:oracle" driver from a Java source file. =0D You need to do the following things...=0D =0D 1.
Make sure you uncomment the loading of the Oracle driver you downloaded: Class.forName("com.oracle.jdbc.OracleDriver"); Also you will need to change your DB URL "dsn" to use the format recognized by the downloaded Enterprise? Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... It looks like your cat" - Gary Larson...DW1: Data Walkthroughs 1.1...DW2: Data Walkthroughs 2.0...DDS: The DataSet Designer Surface...ANO: ADO.NET2 Orientation...DAN: Deeper ADO.NET...DNU...PQ Reply With Quote Quick Navigation Java Programming Top Site
This (or something similar!): >> static public String dsn =3D"jdbc:oracle:thin://con02:1521;SID=3Dinfo"; Not this: >> static public String dsn =3D"jdbc:tibcosoftwareinc:oracle://con02:1521; SID=3Dinfo"; I haven't personally encountered this error myself so I'm *shooting in the Take our survey and automatically be enter to win anyone of the following: Yeti Cooler, Amazon eGift Card, and Movie eGift Card! Learn more about SAP Q&A SQL exception: This driver is locked for use with embedded applications. Other parts of the app also hit a separate SQL 2000 database. 0 LVL 27 Overall: Level 27 Microsoft SQL Server 23 Microsoft SQL Server 2005 16 Java 1 Message
It sounds like you are still getting a reference to the old driver. I've found that there's less trouble using jdbc drivers from database providers instead of using Tibco drivers. Creating a database connection for CloverETL graph execution A database connection lets your CloverETL graph components connect to a database. Join Now For immediate help use Live now!
Home | Invite Peers | More Enterprise Architecture and EAI Groups Your account is ready. this time, idid: =2E put all C:/oracle/Ora9i/jdbc/lib/classes12=2Ezip; C:/oracle/Ora9i/jdbc/lib/classes111=2Ezip to %TRA_HOME%/lib dir, it is defined in designer=2Etra as: tibco=2Eenv=2ETRA_HOME C:/tibco/tra/5=2E1 =2E also, confirm %TRA_HOME%/lib%PSP% is in the classpath: # Set CLASS PATH sunny replied Oct 8, 2004 Thanks a lot=2Ereally sorry to bother you too long! Thanks sunny Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Results 1 to 2 of 2 Thread: How can I release this embeded locked Oracle JDBC Driver for my current uas?? Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM