[resolved] Pervasive (Btrieve) Metadata Connection

[Anonymous]

hi all
I Have to work with Pervasive Data, but got some problem with metadata connection.
Even if I add classpath in Talend' java build Path class still "not found" .
First Trying with a Talend job : first error come from Class jpscs.jar . Talend can't find it (even if put in Build path) .
Problem resolved with a tLibraryLoad.
But by this way I've to know the schema (and cannot do migration in a Sql Database "on the fly") !
Do a test with a metadata description and Generic JDBC metadata.
But never find the Driver class ! So no way to guess shema from Pervasive database.
How can I make JDBC metadata works with pervasive database ?
Seems that metadata JDBC didn't add classpath of the driver.
env :
Talend Open Studio
Version: 3.1.3
Build id: r26090-20090629-1316

Edit : i've also added the .jar files in Talend lib directory !
thanks for your help
Regards
laurent

[Anonymous]

Perhaps It could work if I import the jar file missing (jpscs.jar) in the JDBC code !
Where can i found source for metadata JDBC to try that way !?
For example if I add an import "import com.pervasive.pscs.Manager" (Class i'm loadind in tLibraryLoad) in " tJDBCConnection_begin.javajet"
I would be able to use shema editor !??
My goal is to be able to retrieve schemas and avoid to define them by hand (work fine if i do that but it's a long way ) and make a migration from btrieve to Sql database.
++

[Anonymous]

ok,
i'm extending JDBC component to working with Pervasive Connection ..(I'll put new Component in the Talend exchange right "onreadystate"
but it shold be helpfully to be able to use metadata db connection ... !
Suggestion or help will be appreciate
regards
laurent

[Anonymous]

.....
With very few modification in the JDBCColumnList (add a PERVASIVE name, ..etc)
, I can read the schema of a pervasive table "on the fly " ... what i'm looking for !
So resolved problem (but hope for some clue to do it with metadta )
Regards
laurent

[Anonymous]

Hello kzone.
I'm using Pervasive as well and got the same problem that you reported about connection. By a chance, have you posted your component?
Best regards

[Anonymous]

hi,
have a look at exchange repository and look for
tJDBCColumnList_extend
tPervasiveConnection
tPervasiveInput
hope it could help you !
laurent
++

[Anonymous · Accepted solution]

Hi
kzone, I'm getting the same message when I download these components:
"Cannot find file"tPervasiveConnection_Component_java.xml" "
Have any thoughts of what can I do about this?
Thanks

[Anonymous]

hi,
and hooo
I'll have a look at this as soon as possible (hope today !)
laurent
EDIT
===
I've downloaded component, unarchived in TOS/plugins/org.talend.designer.components.localprovider_xxx and copied .jar in TOS/lib/java repository and it looks like OK ! (try with TOS Version: 4.0.0M2
Build id: r35653-20100114-0503 )
Use you own repository (@see preferences=>Talend=>components=>path to you user component) if you don't want to share "native" and " imported" talend component !
ps :Are talking about "tPervasiveConnection_java.xml" ?

++

[Anonymous]

Hi kzone
Sorry, took me some time put my notebook to work ok and get the 4.0M3.
Anyway, i tried with the M3 in talend exchange, download the Pervasive components, but it gave me the same message.
Any clue about what is missing?
Many thanks

[Anonymous]

ok ,
i've (re)done the extraction and I see what's wrong ! (i hope
When you extract Component pervasive connection you've got a repository (tPervasiveConnection_Component) and inside "lib" and "tPervasiveConnection" ....
It's tPervasiveConnection you have to copy in your Talend repository componenet and not tPervasiveConnection_Component ! (it's the reason why talend 's looking for tPervasiveConnection_Component_java.xml )
files "jar" are going into yourTalend/lib/java .
hope it's clear enought
regards
laurent